package jdbc;
/*
用户登录功能

程序启动后要求用户输入用户名和密码
使用该用户和密码去userinfo中查询数据，如果可以查询到该记录，则登录成功
否则提示用户：用户名或密码错误
 */
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;


public class LoginDemo {
    public static void main(String[] args) {
        UserInfo userInfo=InputUtil.getInputObject(new UserInfo(),"用户登录","登录");
        try(Connection connection=DBUtil.getConnection()) {
            Statement statement=connection.createStatement();
            String sql="SELECT id,username,password,nickname,age " +
                    "FROM userinfo " +
                    "WHERE username='"+userInfo.getUsername()+"' " +
                    "AND password='"+userInfo.getPassword()+"'";

            ResultSet resultSet = statement.executeQuery(sql);
            if (resultSet.next()){
                System.out.println("登录成功");
            }else{
                System.out.println("用户名或密码错误");
            }
            statement.close();
        } catch (SQLException e) {
            throw new RuntimeException(e);
        }
    }
}
